
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspFAQItem_UPDATE
(
@faqItemId int = null,
@question nvarchar(4000) = null,
@answer nvarchar(4000) = null,
@orderNumber int = null,
@isDeleted bit = null,
@createDate datetime = null,
@lastModifiedDate datetime = null
)
AS

UPDATE
  [dbo].[FAQItem]
SET
  [Question] = @question,
  [Answer] = @answer,
  [OrderNumber] = @orderNumber,
  [IsDeleted] = @isDeleted,
  [CreateDate] = @createDate,
  [LastModifiedDate] = @lastModifiedDate
WHERE
  [FaqItemId] = @faqItemId

GO
